﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using System.Web.Services;
using System.Web.Services.Protocols;


namespace EhotelSystem.FrontviewWebpage
{
    public partial class Home : System.Web.UI.Page
    {
        string sql;
        HotelService.Service1 Webservice = new HotelService.Service1();

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            
         
            sql = "SELECT  hotelName, address FROM hotel";
            //sql = ("SELECT  * FROM hotel INNER JOIN hoteltype ON hotel.hotelTypeID = hoteltype.hotelTypeID WHERE (hotel.hotelID" + "hotelID ='" + (hotelID + "')"));
            DataSet result;
            result = Webservice.SelectData(sql);

            lblhotelName.Text = result.Tables["table"].Rows[0][0].ToString();
            lblhotelAddress.Text = result.Tables["table"].Rows[0][1].ToString();
          
                
        }

        protected void DropDownList9_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}
